Cloud Administrator's Help System

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Install and Configure the JDBC Driver

You must install and configure a driver on every workstation that will be used to connect to the Vantagepoint database.

JDBC enables the use of a Java-based API for access to the cloud database.

The user who installs the JDBC drivers must, at a minimum, have local administrator privileges.

To install and configure the JDBC driver:

  1. Download the JDBC driver installer from the following link:
    https://dsm.deltek.com/DFVE/ODBC/HDPJDBCDriver.zip
  2. Extract all the files in the downloaded ZIP file to a folder on your computer.
  3. Execute either the 32-bit or 64-bit .EXE installer file.
    Execute the file that corresponds to the application from which you will be connecting via JDBC. For example, if the JDBC connection will be made from the 32-bit version of Excel, then use the 32-bit version of the installer (regardless of the architecture of the operating system).
  4. Run the JDBC driver installer; follow the prompts, accepting all of the defaults.
  5. From the JDBC Data Source Administrator dialog box, create either a User DSN or System DSN.
    User DSNs are for a single user; System DSNs are available to all users of the workstation. Select the User DSN or System DSN tab, based on your needs.
  6. Click Add.
  7. On the Create New Data Source dialog box, select DataDirect HDP 4.6 and click Finish.
  8. On the JDBC Cloud Driver Setup dialog box, enter a name in the Data Source field.
    This can be any name that helps you identify the data source. You do not need to add a value in the Description field.
  9. In the Hybrid Data Pipeline Source field, enter the database name and service URL that you received from Deltek Customer Care when you requested the JDBC accounts; leave the Port Number field as is.
    Important: When you enter the service URL, do not include the https:// if that was included in the service URL you received. Including the https:// will result in an error when testing the connection.
  10. On the Security tab, make sure that the Enable SSL checkbox is selected.
  11. Click Test Connect, enter the credentials that you received from Deltek Customer Care when you requested the JDBC accounts, and click OK.
  12. When the message A Connection established! displays, click OK.
  13. On the JDBC Cloud Driver Setup dialog box, click OK.
  14. On the JDBC Data Source Administrator dialog box, click OK.